﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_CM_AddLinkman]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_CM_AddLinkman];
GO
CREATE PROCEDURE [dbo].[sproc_CM_AddLinkman]
@ClientID int,
@name nvarchar(50),
@mobile nvarchar(50),
@telephone nvarchar(50),
@position nvarchar(50),
@email nvarchar(50),
@gender bit,
@description nvarchar(50),
@address nvarchar(100),
@family nvarchar(200)

AS

    INSERT INTO UDS_CM_Linkman(clientid,name,mobile,telephone,position,email,gender,description,address,family)
        VALUES(@ClientID,@name,@mobile,@telephone,@position,@email,@gender,@description,@address,@family)
    RETURN @@IDENTITY